<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Northwind" assembly="NHibernate.Class">
    <class name="Northwind.Order, NHibernate.Class" table="[dbo].[Orders]" lazy="true">
        <id name="OrderID" type="Int32">
            <column name="OrderID" not-null="false" unique="true" />
            <generator class="native" />
        </id>
        <property name="OrderDate" type="DateTime">
            <column name="OrderDate" not-null="false" />
        </property>
        <property name="RequiredDate" type="DateTime">
            <column name="RequiredDate" not-null="false" />
        </property>
        <property name="ShippedDate" type="DateTime">
            <column name="ShippedDate" not-null="false" />
        </property>
        <property name="Freight" type="Decimal">
            <column name="Freight" not-null="false" />
        </property>
        <property name="ShipName" type="String">
            <column name="ShipName" length="40" not-null="false" />
        </property>
        <property name="ShipAddress" type="String">
            <column name="ShipAddress" length="60" not-null="false" />
        </property>
        <property name="ShipCity" type="String">
            <column name="ShipCity" length="15" not-null="false" />
        </property>
        <property name="ShipRegion" type="String">
            <column name="ShipRegion" length="15" not-null="false" />
        </property>
        <property name="ShipPostalCode" type="String">
            <column name="ShipPostalCode" length="10" not-null="false" />
        </property>
        <property name="ShipCountry" type="String">
            <column name="ShipCountry" length="15" not-null="false" />
        </property>
        <many-to-one name="Customer" column="CustomerID" class="Customer" not-null="true" />
        <many-to-one name="Employee" column="EmployeeID" class="Employee" not-null="true" />
        <many-to-one name="Shipper" column="ShipVia" class="Shipper" not-null="true" />
    </class>
</hibernate-mapping>

